Skip to main content

date

1. Description​

The Date Calculation Type is used to fetch date fields from an input file.

2. Screen Configuration​

date_image

Here AccOpenDate is searched in base reference file. If it is not present then default value(LastResDate) is assigned.LastResDate should be present in output metadata or should be declared in additional derivatives.

Click ⬇️ to download the sample data.

3. Required Fields​

  • name: Output Field Name.
  • data_type: Output Field Type.(ShortDate or LongDate)
  • derivation
    • derivation_type: The calculation type used to derive this output field, which for date is "DATE".
    • req_fields
      • name: Metadata field name from the input metadata to fetch for the output field.
      • default_value:Field name from input metadata or output config or constants metadata which needs to be derived when date is not found in base file.